Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Complete syntax reference for Run Stored-Procedure

The following syntax shows the RUN STORED-PROC statement and all options that can be used with the statement. However, keep in mind that not all options shown can be used simultaneously.

Syntax

RUN STORED-PROCEDURE procedure-name [[LOAD-RESULT-INTO <handle> [<int> = PROC-STATUS]] |      [<int> = PROC-HANDLE]]      [ NO-ERROR ]     [([INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression, ...         [INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression )]

Note: In the RUN STORED-PROCEDURE syntax, note that the <handle> is either a pure handle or a handle that points to a temp-table. For more information about the use of temp-table handle with the LOAD-RESULT-INTO phrase, see the "LOAD-RESULT-INTO phrase" section.

Syntax

CLOSE STORED-PROCEDURE procedure-name [ integer-field = PROC-STATUS ] [ WHERE PROC-HANDLE = integer-field ]

The CLOSE STORED-PROCEDURE is not used when the LOAD-RESULT-INTO keyword is used with the RUN-STORED-PROCEDURE statement. See "Closed Stored-Procedure statement" section.

See these sections for valid combinations and usage of these syntax elements:

"Run Stored-Proc statement execution without the LOAD-RESULT-INTO phrase" section.
"Run Stored-Proc statement execution with the LOAD-RESULT-INTO phrase" section.
"Run Stored-Proc statement execution using the send-sql-statement option" section.

The following sections describe the syntax elements and options in detail. This section also presents examples that describe typical situations in which you might use the various options that the RUN STORED-PROC statement supports.